﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="test.aspx.cs" Inherits="cwdz.test" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
        BgDate:<asp:Label ID="BgDateLabel" runat="server" Text="Label"></asp:Label>
        ,EdDate:<asp:Label ID="EdDateLabel" runat="server" Text="Label"></asp:Label>
    
        <br />
        <br />
    
    </div>
    <table style="width:100%;">
        <tr>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td>
                &nbsp;</td>
            <td>
                <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
                    DataSourceID="SqlDataSource1" EnableModelValidation="True">
                    <Columns>
                        <asp:BoundField DataField="YWORGNAME" HeaderText="YWORGNAME" 
                            SortExpression="YWORGNAME" />
                        <asp:BoundField DataField="BILLNO" HeaderText="BILLNO" SortExpression="BILLNO" 
                            Visible="False" />
                        <asp:BoundField DataField="YWBILLNO" HeaderText="YWBILLNO" 
                            SortExpression="YWBILLNO" />
                        <asp:BoundField DataField="REMARK" HeaderText="REMARK" 
                            SortExpression="REMARK" />
                        <asp:BoundField DataField="JTAXRATE" HeaderText="JTAXRATE" 
                            SortExpression="JTAXRATE" />
                        <asp:BoundField DataField="WJTOTAL" HeaderText="WJTOTAL" ReadOnly="True" 
                            SortExpression="WJTOTAL" />
                        <asp:BoundField DataField="HJTOTAL" HeaderText="HJTOTAL" ReadOnly="True" 
                            SortExpression="HJTOTAL" />
                    </Columns>
                </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:ConnectionStringOra %>" 
                    ProviderName="<%$ ConnectionStrings:ConnectionStringOra.ProviderName %>" 
                    SelectCommand="SELECT YWORGNAME, BILLNO, YWBILLNO, REMARK, JTAXRATE, SUM(WJTOTAL) AS WJTOTAL, SUM(HJTOTAL) AS HJTOTAL FROM TACPJSJXBODY WHERE (BILLNO = '1001YFJS201204060005') GROUP BY YWORGNAME, BILLNO, YWBILLNO, REMARK, JTAXRATE ORDER BY YWBILLNO">
                </asp:SqlDataSource>
            </td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
    </table>
    </form>
</body>
</html>
